Release 10.1A: OpenEdge Getting Started:
New and Revised Features
DataServers
Release 10.1A includes the following enhancements in support of DataServer MS SQL Server ORACLE DataServers’ stored procedures functionality:
- Use of the
LOAD-RESULT-INTOfunction.Defined as part of the
RUN STORED-PROCEDUREstatement, theLOAD-REULT-INTOphrase enables an RDBMS stored procedure or send-sql-statement to be executed against a foreign data source for which the result sets that are derived can be loaded directly into one or more Progress static and/or dynamic temp-tables. The data in temp-tables can then be manipulated, employing all capabilities inherent to temp-tables.Depending on the type of temp-table you choose to populate using the
LOAD-RESULT-INTOphrase, preliminary data setup tasks might be required. For example, result sets returned to a static or dynamic-prepared temp-table require you to define the layout of the result set data. In contrast, you do not have to perform any data setup tasks for a dynamic-unprepared temp-table; the temp-table’s schema is based on the result-set schema and a mapping of default Progress data types for each SQL type.As an enhancement to current stored procedure techniques, the use of the
LOAD-RESULT-INTOphrase enables you to extend your code in new ways to more effectively employ more Progress 4GL features and functionality.- Support for
ROWIDfunctionalityMade possible through the use of the optional
LOAD-RESULT-INTOfunction in theRUN STORED-PROCEDUREstatement, Release 10.1A supports a new adaptation ofROWIDfunctionality, which in turn supports an alternative means to populate temp-tables of a ProDataSet Object.The purpose and default behavior of the
ROWIDfunction has not changed. That is, theROWIDcontinues to represent a unique key in a database even through it is not stored directly in the MS SQL data source. However, when used in the context of mapping a temp-tableROWIDto a dataserver record identifier facilitated by the use ofLOAD-RESULT-INTO, these values can be interpreted from one to the other (for example, from record id toROWID.) TheROWIDis stored along side its corresponding result rows within the temp-table.For detailed syntax updates to the
RUN STORED-PROCEDUREstatement, example usages of theLOAD-RESULT-INTOphrase andROWIDfunction, and more information about this functionality, see:
|
Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |